﻿
using System;
using System.Collections.Generic;
using System.Linq;
using SqlSugar;

namespace ZR.Model.MES.op
{
    namespace ZR.Model.mes.md
    {
        /// <summary>
        /// 操作统计表
        ///</summary>
        [SugarTable("op_statistics")]
        public class OpStatistics
        {
            /// <summary>
            /// 工作车间 
            ///</summary>
            [SugarColumn(ColumnName = "workshop_id")]
            public string WorkshopId { get; set; }
            /// <summary>
            /// 工作车间 
            ///</summary>
            [SugarColumn(ColumnName = "workshop_name")]
            public string WorkshopName { get; set; }
            /// <summary>
            /// 生产日期 
            ///</summary>
            [SugarColumn(ColumnName = "productDate")]
            public DateTime? ProductDate { get; set; }
            /// <summary>
            /// 计划数量 
            ///</summary>
            [SugarColumn(ColumnName = "planNum")]
            public int? PlanNum { get; set; }
            /// <summary>
            /// 已经生产数量 
            ///</summary>
            [SugarColumn(ColumnName = "productedNum")]
            public int? ProductedNum { get; set; }
            /// <summary>
            /// 良品数量 
            ///</summary>
            [SugarColumn(ColumnName = "goodproductsNum")]
            public int? GoodproductsNum { get; set; }
            /// <summary>
            /// 不良品数量 
            ///</summary>
            [SugarColumn(ColumnName = "defectiveProductsNum")]
            public int? DefectiveProductsNum { get; set; }
            /// <summary>
            /// 生产开始时间 
            ///</summary>
            [SugarColumn(ColumnName = "product_starttime")]
            public DateTime? ProductStarttime { get; set; }
            /// <summary>
            /// 生产结束时间 
            ///</summary>
            [SugarColumn(ColumnName = "product_endtime")]
            public DateTime? ProductEndtime { get; set; }
            /// <summary>
            /// 线体id 
            ///</summary>
            [SugarColumn(ColumnName = "line_id")]
            public string LineId { get; set; }
            /// <summary>
            /// 线体名称 
            ///</summary>
            [SugarColumn(ColumnName = "line_name")]
            public string LineName { get; set; }
            /// <summary>
            ///  
            ///</summary>
            [SugarColumn(ColumnName = "CREATED_BY")]
            public string CreatedBy { get; set; }
            /// <summary>
            ///  
            ///</summary>
            [SugarColumn(ColumnName = "CREATED_TIME")]
            public string CreatedTime { get; set; }
            /// <summary>
            ///  
            ///</summary>
            [SugarColumn(ColumnName = "UPDATED_BY")]
            public string UpdatedBy { get; set; }
            /// <summary>
            ///  
            ///</summary>
            [SugarColumn(ColumnName = "UPDATED_TIME")]
            public string UpdatedTime { get; set; }
            /// <summary>
            ///  
            ///</summary>
            [SugarColumn(ColumnName = "id", IsPrimaryKey = true, IsIdentity = true)]
            public int Id { get; set; }
        }
    }

}
